• All Files

Hashids Decode

The Hashids Decode algorithm allows you to decode hash values back into numeric values.

 

The example of this data manipulation can be seen in the table below:

 

Source Column Target Column
yr8 347
3kTMd 27, 986

 

 

To configure the Hashids Decode step, follow the instructions below:

 

  1. In the Admin Navigation tree, select Interfaces > InterfaceName > Tasks > TaskName > Steps.
  2. On the toolbar, click New >New Manipulate Step.

Creating a New Manipulate Step

  1. Navigate to the Keys section and select Hashids Decode.

Keys Section

  1. In the Hashids Decode work area, fill in the following fields:

Common Fields

The following table describes these fields available for this step:

 

Fields Description

Name

Provide a distinctive name for this step.

Is Active

Select the check box to engage the scheduler for this step.

Order of Execution

Enter the order in which this step should be executed.

Filter Expression

Optional. Use this filed to filter data from the source database prior to inserting it into the Schema table.

Sort Expression

Optional. Use this field to sort data from the source database prior to inserting it into the Schema table.

Stop interface execution if query failed

Optional. If enabled, the system will stop any data manipulation if the query returns an error.

Save Schema (enabled per interface)

If selected, the schema is created for this step.
Is Multi Mapping

If you choose this option than you can manipulate multiple different columns at the same step.

Source Column

Specify the column that contains the source data you want to decode.

Target Column

Specify the destination column where the result of the operation will be stored.

Salt

A string that will be used to permute the hash value and make it decodable only by using the same salt that was provided during encoding.

Characters

A string of characters to be used in the resulting hash value. By default, characters from the Latin alphabet and digits are used.

Min Length

The minimum length of the resulting hash.

 

  1. Click the Save button.